package com.by.zhdoctor.mapper;


import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;


/**
 * Created by Lawrence on 2017/6/5.
 */
@Mapper //指定该接口对应的是mybatis映射接口
public interface VisualizationMapper {
    int findAllD_STAT();
    int statDoctorsExpr();
    int statUsers();
    int statUsersAct();
    int statRecipe();
    int statSeekRecipe();
    @Select("TRUNCATE TABLE d_m_zhenghe_user_stat")
    void deleteUserStatAll();
    @Select("TRUNCATE TABLE d_m_zhenghe_doctor_stat")
    void deleteDoctorStatAll();
    @Select("TRUNCATE TABLE d_m_zhenghe_doctor_expr_stat")
    void deleteDoctorExprStatAll();
    @Select("TRUNCATE TABLE d_m_zhenghe_act_user_stat")
    void deleteActUserStatAll();
    @Select("TRUNCATE TABLE d_m_zhenghe_recipe_stat")
    void deleteRecipeStatAll();
    @Select("delete from d_m_zhenghe_seekrecipe_stat where month_id = month(sysdate())")
    void deleteSeekRecipeStatcCurrentMonth();
}
